Dashboard 03 - Creating Cards and Slicer 23


In this step, we will create cards in the 3rd dashboard / page RaleighPoliceIncidents-Street.



To help you get started, you can copy the following cards from Dashboard 02, RaleighPoliceIncidents-District, to this dashboard.

Click on the chart/card/slicer, press Ctrl+C to copy and Ctrl+V to paste it. 


Years

Select a District

Select a Crime Category Type





Step 1:  Create Street Block Address Card

In Power BI Desktop, click on the page, RaleighPoliceIncidents-Street

Click on the 'Select a District', press Ctrl+C to copy and Ctrl+V to paste it. 

From the copied 'Select a District' card from Dashboard 02, RaleighPoliceIncidents-District, to this dashboard, set up as follows:


Visualizations

Click the Card icon

Fields

Select the following:

A_KeyMeasures ->  .Measure_Reported_Block_Address


Visualizations

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card to Select Block Address

Under Format ->  General: X Position = 244  , Y Position = 120 , Width = 349 , Height = 36

Under Format ->  Data Label ->  Color = 094780 , Text Size = 19 pt , Font = DIN (default)

Under Format -> Category ->  Set it to OFF

Under Format -> Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = CCCCCC



Step 2 - Move the 'Select a District' card to the following position:

Under Format ->  General: X Position = 944 , Y Position = 120 , Width = 455 , Height = 36


Step 3 - Move the 'Select a Crime Category Type' card to the following position:

Under Format ->  General: X Position = 593 , Y Position = 120 , Width = 351 , Height = 36





Step 4:  Create Average Police Incidents Per Day Card

Click on the 'Select a District', press Ctrl+C to copy and Ctrl+V to paste it. 

From the copied 'Select a District' card from Dashboard 02, RaleighPoliceIncidents-District, to this dashboard, set up as follows:

Visualizations

Click the Card icon

Fields

Select the following:

A_KeyMeasures ->  .AVG_Date_Diff_CasesPerDay


Visualizations

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card to Avg Date Diff Per Day

Under Format ->  General: X Position = 0 , Y Position = 63 , Width = 244 , Height = 93

Under Format ->  Data Label ->  Color = 094780 , Value Decimal Values = 1 ,  Text Size = 35 pt , Font = DIN (default)

Under Format -> Category ->  Set it to OFF

Under Format -> Title ->  Set it to ON , Title Text = Avg Police Incidents Per Day , Font Color = 094780 , Background Color = E6E6E6 , Alignment = Center , Text Size = 15 pt , Font Family = DIN (Default)

Under Format ->  Background ->  Set it to ON , Color = FFFFFF

Under Format ->  Border ->  Set it to ON , Color = 666666




Step 5:  Create Year Slicer

Click on the chart/card/slicer, press Ctrl+C to copy and Ctrl+V to paste it. 

From the copied Year card from Dashboard 02, RaleighPoliceIncidents-District, to this dashboard, set up as follows:


Visualizations

Click the Slicer icon

Fields

Select the following:

Raleigh_Police_Incidents_NIBRS ->  Reported_Date ->  Date Hierarchy ->  Year


Visualizations

As per earlier steps, configure fields as follows:


Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card to YOY Major Crime Rate 

Under Format ->  General: X Position = 944  , Y Position = 0 , Width = 250 , Height = 120

Under Format ->  Numeric Inputs ->  Font Color = 000000, Text Size = 13 pt , Font = Segoe UI

Under Format -> Slider ->  Set it to ON ->  Color = 094780

Under Format -> Title ->  Set it to ON , Title Text = Years, Font Color = 094780 , Background Color = E6E6E6 , Alignment = Center , Text Size = 17 pt , Font Family = DIN (Default)

Under Format ->  Background ->  Set it to ON , Color = FFF

Under Format ->  Border ->  Set it to ON , Color = 666666


Summary:


When finished, save the project.









How to create a Card visualization in Power BI


How to create a Slicer visualization in Power BI